home *** CD-ROM | disk | FTP | other *** search
/ TPUG - Toronto PET Users Group / TPUG Users Group CD / TPUG Users Group CD.iso / AMIGA / AMICUS / AMICUS11.ADF / Analyze Templates / Amort.sht (.txt) < prev    next >
The Works! Spreadsheet  |  1986-08-05  |  4KB  |  85 lines
  1. 'Amort3.0.sam.sht
  2.     'AmiSoft
  3. 'Loan Amortization
  4. 'LOAN AMOUNT
  5. '    Years of loan
  6. 'INTEREST RATE
  7. '    Year to display--->
  8. ^month
  9. ^principal 
  10. ^interest
  11.     ^balance
  12. (12*(F5-1))
  13. +$C$4/($Z$13^A8)*($Z$13^A8-$Z$15)/(1-$Z$15)
  14. '  Payment
  15. +AMT*I/(1-(V^(12*TERM)))
  16. +1+A8
  17. +$F$8-C9
  18. +$I*D8
  19. +$C$4/($Z$13^A9)*($Z$13^A9-$Z$15)/(1-$Z$15)
  20. +1+A9
  21. +$F$8-C10
  22. +$I*D9
  23. +$C$4/($Z$13^A10)*($Z$13^A10-$Z$15)/(1-$Z$15)
  24.     '  Total
  25. +1+A10
  26. +$F$8-C11
  27. Q+$I*D10
  28. +$C$4/($Z$13^A11)*($Z$13^A11-$Z$15)/(1-$Z$15)
  29. '  Payments
  30. +1+A11
  31. +$F$8-C12
  32. "+$I*D11
  33. +$C$4/($Z$13^A12)*($Z$13^A12-$Z$15)/(1-$Z$15)
  34. '  This year
  35. @SUM(B9..C20)
  36. +C5/12
  37. +1+A12
  38. +$F$8-C13
  39. +$I*D12
  40. +$C$4/($Z$13^A13)*($Z$13^A13-$Z$15)/(1-$Z$15)
  41. +1/(1+I)
  42. +1+A13
  43. +$F$8-C14
  44. +$I*D13
  45. =+$C$4/($Z$13^A14)*($Z$13^A14-$Z$15)/(1-$Z$15)
  46. +1+A14
  47. C.+$F$8-C15
  48. np+$I*D14
  49. +$C$4/($Z$13^A15)*($Z$13^A15-$Z$15)/(1-$Z$15)
  50. D+V^(12*TERM)
  51. +1+A15
  52. W+$F$8-C16
  53. +$I*D15
  54. +$C$4/($Z$13^A16)*($Z$13^A16-$Z$15)/(1-$Z$15)
  55. +1+A16
  56. +$F$8-C17
  57. @TZn{
  58. ]+$I*D16
  59. +$C$4/($Z$13^A17)*($Z$13^A17-$Z$15)/(1-$Z$15)
  60. +1+A17
  61. +$F$8-C18
  62. I+$I*D17
  63. +$C$4/($Z$13^A18)*($Z$13^A18-$Z$15)/(1-$Z$15)
  64. +1+A18
  65. +$F$8-C19
  66. +$I*D18
  67. +$C$4/($Z$13^A19)*($Z$13^A19-$Z$15)/(1-$Z$15)
  68. +1+A19
  69. +$F$8-C20
  70. 3+$I*D19
  71. +$C$4/($Z$13^A20)*($Z$13^A20-$Z$15)/(1-$Z$15)
  72. !'                               
  73. Amort3.0.sa
  74. Amort3.0.sa
  75. Amort3.0.sa
  76. Amort3.0.sa
  77. Amort3.0.sa
  78. Amort3.0.sa
  79. Amort3.0.sa
  80. Amort3.0.sa
  81. month
  82. mort3.0.sa
  83. mort3.0.sa
  84. mort3.0.sa
  85.